import openpyxl 

def save1(sname):
  wb = openpyxl.Workbook()
  # ws = wb.active
  ws = wb.copy_worksheet(data[sname])
  wb.save('数据持久化\\xlsx\\'+sname+'.xlsx')

data = openpyxl.load_workbook('数据持久化\\疫苗数据.xlsx')
sheets = data.sheetnames
for i in sheets:
  save1(i)

